USE EMODE


GO
ALTER TABLE ARTICLE_COLOR_LOOKUP ADD PRIMARY KEY (ARTICLE_CODE,COLOR_CODE)
  

GO
ALTER TABLE ARTICLE_LOOKUP ADD PRIMARY KEY (ARTICLE_CODE)
  

GO
ALTER TABLE CALENDAR_YEAR_LOOKUP ADD PRIMARY KEY (WEEK_KEY)
  

GO
ALTER TABLE OUTLET_LOOKUP ADD PRIMARY KEY (SHOP_CODE)


GO
ALTER TABLE SHOP_FACTS ADD PRIMARY KEY (ID)
